﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="OficinaDataSet" targetNamespace="http://tempuri.org/OficinaDataSet.xsd" xmlns:mstns="http://tempuri.org/OficinaDataSet.xsd" xmlns="http://tempuri.org/OficinaDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="OficinaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="OficinaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CSharp2.Capitulo03.Oficina.Properties.Settings.GlobalReference.Default.OficinaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClienteTableAdapter" GeneratorDataComponentClassName="ClienteTableAdapter" Name="Cliente" UserDataComponentName="ClienteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Cliente" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cliente] WHERE (([Id] = @Original_Id) AND ([Nome] = @Original_Nome) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([DataNascimento] = @Original_DataNascimento) AND ([Tipo] = @Original_Tipo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DataNascimento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cliente] ([Nome], [Email], [DataNascimento], [Tipo]) VALUES (@Nome, @Email, @DataNascimento, @Tipo);
SELECT Id, Nome, Email, DataNascimento, Tipo FROM Cliente WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DataNascimento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Nome, Email, DataNascimento, Tipo FROM dbo.Cliente</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cliente] SET [Nome] = @Nome, [Email] = @Email, [DataNascimento] = @DataNascimento, [Tipo] = @Tipo WHERE (([Id] = @Original_Id) AND ([Nome] = @Original_Nome) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([DataNascimento] = @Original_DataNascimento) AND ([Tipo] = @Original_Tipo));
SELECT Id, Nome, Email, DataNascimento, Tipo FROM Cliente WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DataNascimento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DataNascimento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Cliente" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="DataNascimento" DataSetColumn="DataNascimento" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClienteVeiculoTableAdapter" GeneratorDataComponentClassName="ClienteVeiculoTableAdapter" Name="ClienteVeiculo" UserDataComponentName="ClienteVeiculoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.ClienteVeiculo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ClienteVeiculo] ([Cliente_Id], [Veiculo_Id]) VALUES (@Cliente_Id, @Veiculo_Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cliente_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cliente_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Veiculo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Veiculo_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Cliente_Id, Veiculo_Id FROM dbo.ClienteVeiculo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Cliente_Id" DataSetColumn="Cliente_Id" />
              <Mapping SourceColumn="Veiculo_Id" DataSetColumn="Veiculo_Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CorTableAdapter" GeneratorDataComponentClassName="CorTableAdapter" Name="Cor" UserDataComponentName="CorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Cor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cor] WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cor] ([Descricao]) VALUES (@Descricao);
SELECT Id, Descricao FROM Cor WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Descricao FROM dbo.Cor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cor] SET [Descricao] = @Descricao WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao));
SELECT Id, Descricao FROM Cor WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Cor" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModeloTableAdapter" GeneratorDataComponentClassName="ModeloTableAdapter" Name="Modelo" UserDataComponentName="ModeloTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Modelo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Modelo] WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao) AND ((@IsNull_Montadora_Id = 1 AND [Montadora_Id] IS NULL) OR ([Montadora_Id] = @Original_Montadora_Id)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Modelo] ([Descricao], [Montadora_Id]) VALUES (@Descricao, @Montadora_Id);
SELECT Id, Descricao, Montadora_Id FROM Modelo WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Descricao, Montadora_Id FROM dbo.Modelo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Modelo] SET [Descricao] = @Descricao, [Montadora_Id] = @Montadora_Id WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao) AND ((@IsNull_Montadora_Id = 1 AND [Montadora_Id] IS NULL) OR ([Montadora_Id] = @Original_Montadora_Id)));
SELECT Id, Descricao, Montadora_Id FROM Modelo WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Montadora_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Montadora_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Modelo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
              <Mapping SourceColumn="Montadora_Id" DataSetColumn="Montadora_Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MontadoraTableAdapter" GeneratorDataComponentClassName="MontadoraTableAdapter" Name="Montadora" UserDataComponentName="MontadoraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Montadora" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Montadora] WHERE (([Id] = @Original_Id) AND ([Nome] = @Original_Nome))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Montadora] ([Nome]) VALUES (@Nome);
SELECT Id, Nome FROM Montadora WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Nome FROM dbo.Montadora</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Montadora] SET [Nome] = @Nome WHERE (([Id] = @Original_Id) AND ([Nome] = @Original_Nome));
SELECT Id, Nome FROM Montadora WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Montadora" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ServicoTableAdapter" GeneratorDataComponentClassName="ServicoTableAdapter" Name="Servico" UserDataComponentName="ServicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Servico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Servico] WHERE (([Id] = @Original_Id) AND ([Veiculo_Id] = @Original_Veiculo_Id) AND ([TipoServico_Id] = @Original_TipoServico_Id) AND ((@IsNull_DataInicio = 1 AND [DataInicio] IS NULL) OR ([DataInicio] = @Original_DataInicio)) AND ((@IsNull_DataFim = 1 AND [DataFim] IS NULL) OR ([DataFim] = @Original_DataFim)) AND ((@IsNull_Valor = 1 AND [Valor] IS NULL) OR ([Valor] = @Original_Valor)) AND ((@IsNull_Custo = 1 AND [Custo] IS NULL) OR ([Custo] = @Original_Custo)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Veiculo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Veiculo_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoServico_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoServico_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataInicio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFim" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Valor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Valor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Valor" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Valor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Custo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Custo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Custo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Custo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Servico] ([Veiculo_Id], [TipoServico_Id], [DataInicio], [DataFim], [Valor], [Custo], [Sigla]) VALUES (@Veiculo_Id, @TipoServico_Id, @DataInicio, @DataFim, @Valor, @Custo, @Sigla);
SELECT Id, Veiculo_Id, TipoServico_Id, DataInicio, DataFim, Valor, Custo, Sigla FROM Servico WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Veiculo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Veiculo_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoServico_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoServico_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Valor" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Valor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Custo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Custo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Veiculo_Id, TipoServico_Id, DataInicio, DataFim, Valor, Custo, Sigla FROM dbo.Servico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Servico] SET [Veiculo_Id] = @Veiculo_Id, [TipoServico_Id] = @TipoServico_Id, [DataInicio] = @DataInicio, [DataFim] = @DataFim, [Valor] = @Valor, [Custo] = @Custo, [Sigla] = @Sigla WHERE (([Id] = @Original_Id) AND ([Veiculo_Id] = @Original_Veiculo_Id) AND ([TipoServico_Id] = @Original_TipoServico_Id) AND ((@IsNull_DataInicio = 1 AND [DataInicio] IS NULL) OR ([DataInicio] = @Original_DataInicio)) AND ((@IsNull_DataFim = 1 AND [DataFim] IS NULL) OR ([DataFim] = @Original_DataFim)) AND ((@IsNull_Valor = 1 AND [Valor] IS NULL) OR ([Valor] = @Original_Valor)) AND ((@IsNull_Custo = 1 AND [Custo] IS NULL) OR ([Custo] = @Original_Custo)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)));
SELECT Id, Veiculo_Id, TipoServico_Id, DataInicio, DataFim, Valor, Custo, Sigla FROM Servico WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Veiculo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Veiculo_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TipoServico_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoServico_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Valor" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Valor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Custo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Custo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Veiculo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Veiculo_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TipoServico_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoServico_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataInicio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInicio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFim" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Valor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Valor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Valor" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Valor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Custo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Custo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Custo" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Custo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Servico" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Veiculo_Id" DataSetColumn="Veiculo_Id" />
              <Mapping SourceColumn="TipoServico_Id" DataSetColumn="TipoServico_Id" />
              <Mapping SourceColumn="DataInicio" DataSetColumn="DataInicio" />
              <Mapping SourceColumn="DataFim" DataSetColumn="DataFim" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="Custo" DataSetColumn="Custo" />
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipoServicoTableAdapter" GeneratorDataComponentClassName="TipoServicoTableAdapter" Name="TipoServico" UserDataComponentName="TipoServicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.TipoServico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipoServico] WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipoServico] ([Descricao]) VALUES (@Descricao);
SELECT Id, Descricao FROM TipoServico WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Descricao FROM dbo.TipoServico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipoServico] SET [Descricao] = @Descricao WHERE (([Id] = @Original_Id) AND ([Descricao] = @Original_Descricao));
SELECT Id, Descricao FROM TipoServico WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.TipoServico" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VeiculoTableAdapter" GeneratorDataComponentClassName="VeiculoTableAdapter" Name="Veiculo" UserDataComponentName="VeiculoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="OficinaConnectionString (Settings)" DbObjectName="Oficina.dbo.Veiculo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Veiculo] WHERE (([Id] = @Original_Id) AND ([Modelo_Id] = @Original_Modelo_Id) AND ([Cor_Id] = @Original_Cor_Id) AND ([Placa] = @Original_Placa) AND ([AnoFabricacao] = @Original_AnoFabricacao) AND ([AnoModelo] = @Original_AnoModelo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Modelo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modelo_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cor_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cor_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Placa" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnoFabricacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoFabricacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnoModelo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoModelo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Veiculo] ([Modelo_Id], [Cor_Id], [Placa], [AnoFabricacao], [AnoModelo]) VALUES (@Modelo_Id, @Cor_Id, @Placa, @AnoFabricacao, @AnoModelo);
SELECT Id, Modelo_Id, Cor_Id, Placa, AnoFabricacao, AnoModelo FROM Veiculo WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Modelo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modelo_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cor_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cor_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Placa" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnoFabricacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoFabricacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnoModelo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoModelo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Modelo_Id, Cor_Id, Placa, AnoFabricacao, AnoModelo FROM dbo.Veiculo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Veiculo] SET [Modelo_Id] = @Modelo_Id, [Cor_Id] = @Cor_Id, [Placa] = @Placa, [AnoFabricacao] = @AnoFabricacao, [AnoModelo] = @AnoModelo WHERE (([Id] = @Original_Id) AND ([Modelo_Id] = @Original_Modelo_Id) AND ([Cor_Id] = @Original_Cor_Id) AND ([Placa] = @Original_Placa) AND ([AnoFabricacao] = @Original_AnoFabricacao) AND ([AnoModelo] = @Original_AnoModelo));
SELECT Id, Modelo_Id, Cor_Id, Placa, AnoFabricacao, AnoModelo FROM Veiculo WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Modelo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modelo_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cor_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cor_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Placa" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnoFabricacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoFabricacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AnoModelo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoModelo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Modelo_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modelo_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cor_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cor_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Placa" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnoFabricacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoFabricacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnoModelo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnoModelo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Oficina.dbo.Veiculo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Modelo_Id" DataSetColumn="Modelo_Id" />
              <Mapping SourceColumn="Cor_Id" DataSetColumn="Cor_Id" />
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="AnoFabricacao" DataSetColumn="AnoFabricacao" />
              <Mapping SourceColumn="AnoModelo" DataSetColumn="AnoModelo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="OficinaDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="OficinaDataSet" msprop:Generator_UserDSName="OficinaDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cliente" msprop:Generator_TableClassName="ClienteDataTable" msprop:Generator_TableVarName="tableCliente" msprop:Generator_TablePropName="Cliente" msprop:Generator_RowDeletingName="ClienteRowDeleting" msprop:Generator_RowChangingName="ClienteRowChanging" msprop:Generator_RowEvHandlerName="ClienteRowChangeEventHandler" msprop:Generator_RowDeletedName="ClienteRowDeleted" msprop:Generator_UserTableName="Cliente" msprop:Generator_RowChangedName="ClienteRowChanged" msprop:Generator_RowEvArgName="ClienteRowChangeEvent" msprop:Generator_RowClassName="ClienteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataNascimento" msprop:Generator_ColumnVarNameInTable="columnDataNascimento" msprop:Generator_ColumnPropNameInRow="DataNascimento" msprop:Generator_ColumnPropNameInTable="DataNascimentoColumn" msprop:Generator_UserColumnName="DataNascimento" type="xs:dateTime" />
              <xs:element name="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" msprop:Generator_UserColumnName="Tipo" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ClienteVeiculo" msprop:Generator_TableClassName="ClienteVeiculoDataTable" msprop:Generator_TableVarName="tableClienteVeiculo" msprop:Generator_TablePropName="ClienteVeiculo" msprop:Generator_RowDeletingName="ClienteVeiculoRowDeleting" msprop:Generator_RowChangingName="ClienteVeiculoRowChanging" msprop:Generator_RowEvHandlerName="ClienteVeiculoRowChangeEventHandler" msprop:Generator_RowDeletedName="ClienteVeiculoRowDeleted" msprop:Generator_UserTableName="ClienteVeiculo" msprop:Generator_RowChangedName="ClienteVeiculoRowChanged" msprop:Generator_RowEvArgName="ClienteVeiculoRowChangeEvent" msprop:Generator_RowClassName="ClienteVeiculoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Cliente_Id" msprop:Generator_ColumnVarNameInTable="columnCliente_Id" msprop:Generator_ColumnPropNameInRow="Cliente_Id" msprop:Generator_ColumnPropNameInTable="Cliente_IdColumn" msprop:Generator_UserColumnName="Cliente_Id" type="xs:int" />
              <xs:element name="Veiculo_Id" msprop:Generator_ColumnVarNameInTable="columnVeiculo_Id" msprop:Generator_ColumnPropNameInRow="Veiculo_Id" msprop:Generator_ColumnPropNameInTable="Veiculo_IdColumn" msprop:Generator_UserColumnName="Veiculo_Id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cor" msprop:Generator_TableClassName="CorDataTable" msprop:Generator_TableVarName="tableCor" msprop:Generator_TablePropName="Cor" msprop:Generator_RowDeletingName="CorRowDeleting" msprop:Generator_RowChangingName="CorRowChanging" msprop:Generator_RowEvHandlerName="CorRowChangeEventHandler" msprop:Generator_RowDeletedName="CorRowDeleted" msprop:Generator_UserTableName="Cor" msprop:Generator_RowChangedName="CorRowChanged" msprop:Generator_RowEvArgName="CorRowChangeEvent" msprop:Generator_RowClassName="CorRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" msprop:Generator_UserColumnName="Descricao">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Modelo" msprop:Generator_TableClassName="ModeloDataTable" msprop:Generator_TableVarName="tableModelo" msprop:Generator_TablePropName="Modelo" msprop:Generator_RowDeletingName="ModeloRowDeleting" msprop:Generator_RowChangingName="ModeloRowChanging" msprop:Generator_RowEvHandlerName="ModeloRowChangeEventHandler" msprop:Generator_RowDeletedName="ModeloRowDeleted" msprop:Generator_UserTableName="Modelo" msprop:Generator_RowChangedName="ModeloRowChanged" msprop:Generator_RowEvArgName="ModeloRowChangeEvent" msprop:Generator_RowClassName="ModeloRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" msprop:Generator_UserColumnName="Descricao">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Montadora_Id" msprop:Generator_ColumnVarNameInTable="columnMontadora_Id" msprop:Generator_ColumnPropNameInRow="Montadora_Id" msprop:Generator_ColumnPropNameInTable="Montadora_IdColumn" msprop:Generator_UserColumnName="Montadora_Id" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Montadora" msprop:Generator_TableClassName="MontadoraDataTable" msprop:Generator_TableVarName="tableMontadora" msprop:Generator_TablePropName="Montadora" msprop:Generator_RowDeletingName="MontadoraRowDeleting" msprop:Generator_RowChangingName="MontadoraRowChanging" msprop:Generator_RowEvHandlerName="MontadoraRowChangeEventHandler" msprop:Generator_RowDeletedName="MontadoraRowDeleted" msprop:Generator_UserTableName="Montadora" msprop:Generator_RowChangedName="MontadoraRowChanged" msprop:Generator_RowEvArgName="MontadoraRowChangeEvent" msprop:Generator_RowClassName="MontadoraRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Servico" msprop:Generator_TableClassName="ServicoDataTable" msprop:Generator_TableVarName="tableServico" msprop:Generator_TablePropName="Servico" msprop:Generator_RowDeletingName="ServicoRowDeleting" msprop:Generator_RowChangingName="ServicoRowChanging" msprop:Generator_RowEvHandlerName="ServicoRowChangeEventHandler" msprop:Generator_RowDeletedName="ServicoRowDeleted" msprop:Generator_UserTableName="Servico" msprop:Generator_RowChangedName="ServicoRowChanged" msprop:Generator_RowEvArgName="ServicoRowChangeEvent" msprop:Generator_RowClassName="ServicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Veiculo_Id" msprop:Generator_ColumnVarNameInTable="columnVeiculo_Id" msprop:Generator_ColumnPropNameInRow="Veiculo_Id" msprop:Generator_ColumnPropNameInTable="Veiculo_IdColumn" msprop:Generator_UserColumnName="Veiculo_Id" type="xs:int" />
              <xs:element name="TipoServico_Id" msprop:Generator_ColumnVarNameInTable="columnTipoServico_Id" msprop:Generator_ColumnPropNameInRow="TipoServico_Id" msprop:Generator_ColumnPropNameInTable="TipoServico_IdColumn" msprop:Generator_UserColumnName="TipoServico_Id" type="xs:int" />
              <xs:element name="DataInicio" msprop:Generator_ColumnVarNameInTable="columnDataInicio" msprop:Generator_ColumnPropNameInRow="DataInicio" msprop:Generator_ColumnPropNameInTable="DataInicioColumn" msprop:Generator_UserColumnName="DataInicio" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataFim" msprop:Generator_ColumnVarNameInTable="columnDataFim" msprop:Generator_ColumnPropNameInRow="DataFim" msprop:Generator_ColumnPropNameInTable="DataFimColumn" msprop:Generator_UserColumnName="DataFim" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Custo" msprop:Generator_ColumnVarNameInTable="columnCusto" msprop:Generator_ColumnPropNameInRow="Custo" msprop:Generator_ColumnPropNameInTable="CustoColumn" msprop:Generator_UserColumnName="Custo" type="xs:decimal" minOccurs="0" />
              <xs:element name="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn" msprop:Generator_UserColumnName="Sigla" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipoServico" msprop:Generator_TableClassName="TipoServicoDataTable" msprop:Generator_TableVarName="tableTipoServico" msprop:Generator_TablePropName="TipoServico" msprop:Generator_RowDeletingName="TipoServicoRowDeleting" msprop:Generator_RowChangingName="TipoServicoRowChanging" msprop:Generator_RowEvHandlerName="TipoServicoRowChangeEventHandler" msprop:Generator_RowDeletedName="TipoServicoRowDeleted" msprop:Generator_UserTableName="TipoServico" msprop:Generator_RowChangedName="TipoServicoRowChanged" msprop:Generator_RowEvArgName="TipoServicoRowChangeEvent" msprop:Generator_RowClassName="TipoServicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" msprop:Generator_UserColumnName="Descricao">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Veiculo" msprop:Generator_TableClassName="VeiculoDataTable" msprop:Generator_TableVarName="tableVeiculo" msprop:Generator_TablePropName="Veiculo" msprop:Generator_RowDeletingName="VeiculoRowDeleting" msprop:Generator_RowChangingName="VeiculoRowChanging" msprop:Generator_RowEvHandlerName="VeiculoRowChangeEventHandler" msprop:Generator_RowDeletedName="VeiculoRowDeleted" msprop:Generator_UserTableName="Veiculo" msprop:Generator_RowChangedName="VeiculoRowChanged" msprop:Generator_RowEvArgName="VeiculoRowChangeEvent" msprop:Generator_RowClassName="VeiculoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Modelo_Id" msprop:Generator_ColumnVarNameInTable="columnModelo_Id" msprop:Generator_ColumnPropNameInRow="Modelo_Id" msprop:Generator_ColumnPropNameInTable="Modelo_IdColumn" msprop:Generator_UserColumnName="Modelo_Id" type="xs:int" />
              <xs:element name="Cor_Id" msprop:Generator_ColumnVarNameInTable="columnCor_Id" msprop:Generator_ColumnPropNameInRow="Cor_Id" msprop:Generator_ColumnPropNameInTable="Cor_IdColumn" msprop:Generator_UserColumnName="Cor_Id" type="xs:int" />
              <xs:element name="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" msprop:Generator_UserColumnName="Placa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnoFabricacao" msprop:Generator_ColumnVarNameInTable="columnAnoFabricacao" msprop:Generator_ColumnPropNameInRow="AnoFabricacao" msprop:Generator_ColumnPropNameInTable="AnoFabricacaoColumn" msprop:Generator_UserColumnName="AnoFabricacao" type="xs:int" />
              <xs:element name="AnoModelo" msprop:Generator_ColumnVarNameInTable="columnAnoModelo" msprop:Generator_ColumnPropNameInRow="AnoModelo" msprop:Generator_ColumnPropNameInTable="AnoModeloColumn" msprop:Generator_UserColumnName="AnoModelo" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cliente" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Cor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cor" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Modelo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Modelo" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Montadora_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Montadora" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Servico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Servico" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="TipoServico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipoServico" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Veiculo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Veiculo" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ClienteVeiculo_Cliente" msdata:parent="Cliente" msdata:child="ClienteVeiculo" msdata:parentkey="Id" msdata:childkey="Cliente_Id" msprop:Generator_UserChildTable="ClienteVeiculo" msprop:Generator_ChildPropName="GetClienteVeiculoRows" msprop:Generator_UserRelationName="FK_ClienteVeiculo_Cliente" msprop:Generator_ParentPropName="ClienteRow" msprop:Generator_RelationVarName="relationFK_ClienteVeiculo_Cliente" msprop:Generator_UserParentTable="Cliente" />
      <msdata:Relationship name="FK_ClienteVeiculo_Veiculo" msdata:parent="Veiculo" msdata:child="ClienteVeiculo" msdata:parentkey="Id" msdata:childkey="Veiculo_Id" msprop:Generator_UserChildTable="ClienteVeiculo" msprop:Generator_ChildPropName="GetClienteVeiculoRows" msprop:Generator_UserRelationName="FK_ClienteVeiculo_Veiculo" msprop:Generator_RelationVarName="relationFK_ClienteVeiculo_Veiculo" msprop:Generator_UserParentTable="Veiculo" msprop:Generator_ParentPropName="VeiculoRow" />
      <msdata:Relationship name="FK_Modelo_Montadora" msdata:parent="Montadora" msdata:child="Modelo" msdata:parentkey="Id" msdata:childkey="Montadora_Id" msprop:Generator_UserChildTable="Modelo" msprop:Generator_ChildPropName="GetModeloRows" msprop:Generator_UserRelationName="FK_Modelo_Montadora" msprop:Generator_RelationVarName="relationFK_Modelo_Montadora" msprop:Generator_UserParentTable="Montadora" msprop:Generator_ParentPropName="MontadoraRow" />
      <msdata:Relationship name="FK_Servico_TipoServico" msdata:parent="TipoServico" msdata:child="Servico" msdata:parentkey="Id" msdata:childkey="TipoServico_Id" msprop:Generator_UserChildTable="Servico" msprop:Generator_ChildPropName="GetServicoRows" msprop:Generator_UserRelationName="FK_Servico_TipoServico" msprop:Generator_RelationVarName="relationFK_Servico_TipoServico" msprop:Generator_UserParentTable="TipoServico" msprop:Generator_ParentPropName="TipoServicoRow" />
      <msdata:Relationship name="FK_Servico_Veiculo" msdata:parent="Veiculo" msdata:child="Servico" msdata:parentkey="Id" msdata:childkey="Veiculo_Id" msprop:Generator_UserChildTable="Servico" msprop:Generator_ChildPropName="GetServicoRows" msprop:Generator_UserRelationName="FK_Servico_Veiculo" msprop:Generator_RelationVarName="relationFK_Servico_Veiculo" msprop:Generator_UserParentTable="Veiculo" msprop:Generator_ParentPropName="VeiculoRow" />
      <msdata:Relationship name="FK_Veiculo_Cor" msdata:parent="Cor" msdata:child="Veiculo" msdata:parentkey="Id" msdata:childkey="Cor_Id" msprop:Generator_UserChildTable="Veiculo" msprop:Generator_ChildPropName="GetVeiculoRows" msprop:Generator_UserRelationName="FK_Veiculo_Cor" msprop:Generator_ParentPropName="CorRow" msprop:Generator_RelationVarName="relationFK_Veiculo_Cor" msprop:Generator_UserParentTable="Cor" />
      <msdata:Relationship name="FK_Veiculo_Modelo" msdata:parent="Modelo" msdata:child="Veiculo" msdata:parentkey="Id" msdata:childkey="Modelo_Id" msprop:Generator_UserChildTable="Veiculo" msprop:Generator_ChildPropName="GetVeiculoRows" msprop:Generator_UserRelationName="FK_Veiculo_Modelo" msprop:Generator_ParentPropName="ModeloRow" msprop:Generator_RelationVarName="relationFK_Veiculo_Modelo" msprop:Generator_UserParentTable="Modelo" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>